MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

34 rows where Object Name = 2301

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Title, Culture, Artist Role, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, City, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
20410 20410 1990.114.2 0 1 24943 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Made for Charles XI of Sweden (1655–1697) French, Paris 114         Gunsmith 96   Bertrand Piraube French, Paris, recorded ca. 1663–1725   Piraube, Bertrand 2923 French 2 1638 1750 dated 1676 1676 1676 Steel, gold, wood (walnut) 3881 L. 21 in. (53.3 cm) Purchase, Annie Laurie Aitken Charitable Trust Gift, 1990   Paris 27                   Firearms 93   http://www.metmuseum.org/art/collection/search/24943 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22411 22411 16.85 0 0 27309 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol French 7                           ca. 1750 1750 1750 Steel, walnut, silver, gold 5027 L. 15 7/8 in. (40.3 cm); L. of barrel 9 3/4 in. (24.8 cm); Cal. .50 in. (12.7 mm); Wt. 1 lb. 10.5 oz. (751.3 g) Rogers Fund, 1916                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/27309 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22476 22476 69.138.1 0 0 27381 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Russian 70                           dated 1749 1749 1749 Steel, silver, gold, wood (walnut), bone 5051 L. 17 3/8 in. (44.1 cm); L. of barrel 11 1/16 in. (28.1 cm); Cal. .60 In. (15.2 mm); Wt. 2 lb. 4 oz. (1020.6 g) Rogers Fund, 1969   Tula 478                   Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/27381 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22578 22578 52.158 0 0 27489 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Italian 36         Gunsmith 96   Giovan Battista Gavezzani     Gavezzani Giovan Battista 3019       ca. 1615 1615 1615 Steel, wood (walnut) 3526 L. 25 1/8 in. (63.8 cm); L. of barrel 18 7/16 in. (46.8 cm); Cal. .50 in. (12.7 mm); Wt. 2 lb. 3 oz. (992.2 g) Rogers Fund, 1952                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/27489 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22659 22659 58.56 0 1 27570 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Balkan, lock and barrel European (probably French) 634                           18th century 1701 1800 Steel, silver, gold 3810 L. 20 1/2 in. (57.1 cm); L. of barrel 13 1/2 in. (34.3 cm); L. of lock 4 5/8 in. (11.8 cm); Cal. .65 in. (16.5 mm); Wt. 2 lb. 12 oz. (1304.1 g) Rogers Fund, 1958                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/27570 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22886 22886 48.84.5 0 0 27861 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol British 6         Barrelsmith|Silversmith 166 Probably|Probably John Hall|John King London, recorded 1738|British, recorded from 1775   Hall, John|King, John 3046   1738 |1775 1800 |1850 ca. 1771–72 1766 1776 Steel, wood (walnut), brass, silver 5228 L. 13 7/8 in. (35.2 cm); L. of barrel 8 1/8 in. (20.6 cm); Cal. .64 in. (16.1 mm); Wt. 1 lb. 11 oz. (765.4 g) Rogers Fund, 1948   London 14                   Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/27861 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22887 22887 48.84.6 0 0 27862 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol British, London or Birmingham 662         Gunsmith 96 Probably by James Grice British, London, recorded 1793–96 , or by Joseph or William Grice, British, Birmingham Grice, James 3047   1790 1800 last quarter of the 18th century 1775 1800 Steel, wood (walnut), brass, bone 5121 L. 11 5/8 in. (29.5 cm); L. of barrel 6 1/2 in. (16.5 cm); Cal. .56 in. (14.1 mm); Wt. 1 lb. 5 oz. (595.3 g) Rogers Fund, 1948   London|Birmingham 589                   Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/27862 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
24559 24559 37.186.7 0 0 29599 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Scottish 41                           1780 1780 1780 Steel, ram's horn, silver 5474 L. 11 7/8 in. (30.2 cm); L. of barrel 7 5/16 in. (18.6 cm); Cal. .63 in. (16 mm); Wt. 1 lb. 5 oz. (595.3 ) Gift of Mrs. D. H. Schmidt, in memory of Theodore Offerman, 1937                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/29599 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
24560 24560 37.186.8 0 0 29600 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Italian (Brescian) 431                           17th century 1601 1700 Steel 658 L. 18 13/16 in. (47.8 cm); L. of barrel 11 15/16 in. (47.8 cm); Cal. .58 in. (14.7 mm); Wt. 1 lb. 15.7 oz. (898.7 g) Gift of Mrs. D. H. Schmidt, in memory of Theodore Offerman, 1937       Brescia 178               Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/29600 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
24569 24569 37.189.4 0 0 29609 Arms and Armor 5 Flintlock pistol 2301 Flintlock Box-Lock Pistol British, London and Birmingham 749         Silversmith|Gunsmith 169 Possibly Charles Freeth|Ketland British, active late 18th century|British, London and Birmingham, active mid- 18th century–1831   Freeth, Charles|Ketland 3063   1700 |1750 1815 |1850 second half 18th century 1725 1800 Steel, wood (walnut), silver 4389 L. 8 3/8 in. (21.3 cm); L. of barrel 4 in. (10.2 cm); Cal. .44 in. (11.3 mm); Wt. 10. 6 oz (300.5 g) Gift of Christian A. Zabriskie, 1937   Birmingham|London 614                   Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/29609 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
24573 24573 37.189.9 0 0 29613 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Italian 36                           18th century 1701 1800 Steel, brass 323 L. 17 1/4 in. (43.8 cm); L. of barrel 11 3/8 in. (28.9 cm); Cal. .54 in. (13.6 mm); Wt. 2 lb. 5 oz. (1048.9 g) Gift of Christian A. Zabriskie, 1937                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/29613 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25359 25359 36.25.2237 0 0 30510 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Caucasian 64                           18th–19th century 1701 1900 Steel, leather, silver, chern, gold 5748 L. 18 3/4 in. (47.6 cm); L. of barrel 13 9/16 in. (34.4 cm); Cal. .54 in (13.7 mm); Wt. 1 lb. 8 oz. (680.4 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30510 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25365 25365 36.25.2245 0 0 30516 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Egyptian 797                           19th century, decorations dated 1829 1801 1900 Steel, silver, gold 3810 L. 18 3/8 in. (46.7 cm); L. of barrel 12 1/8 in. (30.8 cm); Cal. .65 in (16.5 mm); Wt. 2 lb. 4.3 oz. (1029.1 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30516 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25368 25368 36.25.2248 0 0 30519 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Turkish 68                           18th–19th century 1701 1900 Steel, wood, silver 3496 L. 18 1/4 in. (46.4 cm); L. of barrel 13 1/2 in. (34.3 cm); Cal. .58 in (14.7 mm); Wt. 1 lb. 11.9 oz. (791 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30519 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25369 25369 36.25.2252 0 0 30520 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Circassian 798                           18th–19th century 1701 1900 Wood, steel, silver, chern, gold 5753 L. 17 3/4 in. (45.1 cm); L. of barrel 11 3/8 in. (28.9 cm); Cal. .62 in (15.7 mm); Wt. 1 lb. 14.9 oz. (876 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30520 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25370 25370 36.25.2254 0 0 30521 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Persian 65                           19th century 1801 1900 Steel, wood, ivory, turquoise, glass 5754 L. 16 3/8 in. (41.6 cm); L. of barrel 10 in. (25.4 cm); Cal. 1.14 in (29 mm); Wt. 1 lb. 13 oz. (822.1 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30521 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25382 25382 36.25.2259 0 0 30534 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Moroccan, Spanish lock 804                           18th–19th century 1701 1900 Steel, wood, iron, brass 5758 L. 14 1/8 in. (35.9 cm); L. of barrel 9 in. (22.9 cm); Cal. .61 in (15.5 mm); Wt. 1 lb. 8.3 oz. (688.9 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30534 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25383 25383 36.25.2260 0 0 30535 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Balkan 519                           18th century 1701 1800 Steel, silver, gold 3810 L. 22 3/4 in. (57.8 cm); L. of barrel 12 in. (30.5 cm); Cal. .58 in (14.7 mm); Wt. 2 lb. 12.7 oz. (1267.2 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30535 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25384 25384 36.25.2261 0 0 30536 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Balkan; lock Turkish 805                           18th–19th century 1701 1900 Steel, silver, gold 3810 L. 20 1/4 (51.4 cm); L. of barrel 12 1/4 in. (31.1 cm); Cal. .67 in (17 mm); Wt. 2 lb. 2.2 oz. (969.6 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30536 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25385 25385 36.25.2262 0 0 30537 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Balkan 519                           18th–19th century 1701 1900 Steel, silver, niello 4038 L. 19 1/2 in. (49.5 cm); L. of barrel 12 1/2 in. (31.8 cm); Cal. .64 in (16.3 mm); Wt. 2 lb. 4.7 oz. (1040.4 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30537 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25390 25390 36.25.2267 0 0 30542 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Moroccan 451                           18th century 1701 1800 Wood, steel, brass 5019 L. 19 1/8 in. (48.6 cm); L. of barrel 12 1/2 in. (31.8 cm); Cal. .67 in (17 mm); Wt. 2 lb. 2.7 oz. (983.7 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30542 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25391 25391 36.25.2268 0 0 30543 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Moroccan 451                           18th century 1701 1800 Steel, brass 323 L. 18 3/4 in. (47.6 cm); L. of barrel 11 3/4 in. (29.8 cm); Cal. .65 in (16.5 mm); Wt. 2 lb. 5 oz. (1048.9 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30543 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25392 25392 36.25.2269 0 0 30544 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Italian, decorated in Balkans 809                           18th–19th century 1701 1900 Steel, silver, coral 5760 L. 19 3/4 in. (50.2 cm); L. of barrel 13 3/4 in. (34.9 cm); Cal. .57 in (14.5 mm); Wt. 2 lb. 0.2 oz. (912.9 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30544 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25393 25393 36.25.2270 0 0 30545 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Balkan 519                           18th century 1701 1800 Steel, gold, silver, coral 5761 L. 19 3/8 in. (49.2 cm); L. of barrel 12 3/4 in. (32.4 cm); Cal. .59 in (15 mm); Wt. 2 lb. 5.7 oz. (1068.8 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30545 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25394 25394 36.25.2264 0 0 30546 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Turkish with European lock 810                           18th century 1701 1800 Steel, silver, wood (walnut) 4332 L. 20 1/2 in. (52.1 cm); L. of barrel 14 1/8 in. (35.9 cm); Cal. .63 in (16 mm); Wt. 2 lb. 4.2 oz. (1026.3 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/30546 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
27154 27154 32.75.132 0 0 32310 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol French 7                           ca. 1815 1790 1840 Steel 658 L. 15 3/4 in. (40 cm); L. of barrel 8 3/8 in. (21.3 cm); Cal. .61 in. (15.5 mm); Wt. 1 lb. 10 oz. (737.1 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/32310 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
27155 27155 32.75.133 0 0 32311 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol French 7                           1694 1694 1694 Steel, wood, silver 3496 L. 19 9/16 in. (49.7 cm); L. of barrel 12 15/16 in. (32.9 cm); Cal. .57 in. (14.4 mm); Wt. 2 lb. 7 oz. (1105.6 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/32311 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28123 28123 19.53.19 0 0 33298 Arms and Armor 5 Flintlock pistol 2301 Four Barreled Flintlock Pistol Belgian 676                           18th century 1701 1800 Steel 658 L. 7 1/4 in. (18.4 cm); L. of barrels 1 5/8 in. (4.1 cm); Cal. of barrel (a) .34 in. (8.6 mm), Cal. of barrel (b) .32 in. (8.1 mm), Cal. of barrel (c) .33 in. (8.4 mm), Cal. of barrel (d) .34 in. (8.6 mm); Wt. 1 lb. 5.2 oz. (601 g) Gift of Charles M. Schott Jr., 1917                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/33298 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28131 28131 19.53.33 0 0 33306 Arms and Armor 5 Flintlock pistol 2301 Flintlock Repeating Pistol with Lorenzoni Action British, London 222         Gunsmith 96   Harvey Walklate Mortimer British, Newcastle-under-Lyme 1753–1819 Hampstead-heath (now London)   Mortimer, Harvey Walklate 3077   1753 1819 ca. 1783–1800 1778 1800 Steel, wood (walnut), silver 4389 L. 15 3/8 in. (39.1 cm); L. of barrel 7 3/8 in. (18.7 cm); Cal. .50 in. (12.7 mm); Wt. 3 lb. 6 oz. (1530.9 g) Gift of Charles M. Schott Jr., 1917   London 14                   Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/33306 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28133 28133 19.53.38 0 0 33308 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Italian 36                           late 17th century 1650 1700 Wood (walnut), silver 6748 L. 19 1/8 in. (48.6 cm); L. of barrel 12 9/16 in. (31.9 cm); Cal. .52 in. (13.2 mm); Wt. 1 lb. 12.2 oz. (799.5 g) Gift of Charles M. Schott Jr., 1917                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/33308 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28136 28136 19.53.43 0 0 33311 Arms and Armor 5 Flintlock pistol 2301 Double-Barreled Over-and-Under Flintlock Pistol British, London and Birmingham 749         Gunsmith 96   George Sturman British, active London, early–mid-19th century   Sturman, George 3095   1800 1875 ca. 1825 1800 1850 Steel, wood (walnut), platinum, brass 6753 L. 14 3/16 in. (36 cm); L. of barrels 8 13/16 in. (20.8 cm); Cal. of upper barrel .64 in. (16.2 mm); Cal. of lower barrel .63 in. (16 mm); Wt. 3 lb. 1.4 oz. (1400.5 g) Gift of Charles M. Schott Jr., 1917   London 14                   Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/33311 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28140 28140 19.53.52 0 0 33317 Arms and Armor 5 Flintlock pistol 2301 Highland Flintlock Pistol Scottish 41                           ca. 1775 1750 1800 Steel, silver, iron 4295 L. 12 3/8 in. (31.4 cm); L. of barrel 7 13/16 in. (19.8 cm); Cal. .58 in. (14.7 mm); Wt. 1 lb. 8.7 oz. (700.2 g) Gift of Charles M. Schott Jr., 1917                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/33317 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28145 28145 19.53.60 0 0 33322 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol British 6         Lock maker 168 Lock probably by William Green British, London, recorded 1718 , or by William Green, British, London, recorded 1723 Green, William 3097   1700 1750 ca. 1700–1730 1680 1750 Steel, wood (walnut), brass, bronze, iron (?) 6758 L. 12 1/2 in. (31.8 cm); L. of barrel 8 1/4 in. (21 cm); Cal. .42 in. (10.7 mm); Wt. 1 lb. 7 oz. (652 g) Gift of Charles M. Schott Jr., 1917                       Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/33322 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
30162 30162 2011.360a, b 0 1 35667 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol possibly Belgian, Liege 1249                           ca. 1650 1625 1675 Steel, iron, wood (walnut) 7185 L. 24 3/4 in. (62.7 cm); L. of barrel 17 1/16 in. (43.3 cm) Purchase, Arthur Ochs Sulzberger Gift, 2011   possibly Liege 694                   Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/35667 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 174.707ms · Data license: CC0 · Data source: metmuseum/openaccess